package cn.com.api.mapper.base;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.*;

import cn.com.api.entity.ApiT_member_entrepreneur;
import cn.com.api.entity.ApiT_member_partner;

//DAO
public interface T_member_partnerMapperBase {

	// 根据id查看
	@Select("SELECT * FROM T_MEMBER_PARTNER  WHERE ID = #{ID}")
	public ApiT_member_partner findT_member_partnerById(Integer id);

	// 查看数据集
	@Select("SELECT * FROM T_member_partner")
	public List<ApiT_member_partner> findT_member_partners();

	// 添加
	public int insertT_member_partner(ApiT_member_partner t_member_partner);

	// 修改
	@Update("UPDATE T_MEMBER_PARTNER SET USER_ID = #{user_id,jdbcType=INTEGER},qrcode_img=#{qrcode_img,jdbcType=VARCHAR},is_pay = #{is_pay,jdbcType=INTEGER},task_id=#{task_id,jdbcType=VARCHAR}, USER_NAME = #{user_name,jdbcType=VARCHAR}, CRED_TYPE = #{cred_type,jdbcType=INTEGER}, CRED_NO = #{cred_no,jdbcType=VARCHAR}, GENDER = #{gender,jdbcType=INTEGER}, PHOTO_FRONT = #{photo_front,jdbcType=VARCHAR}, PHOTO_BACK = #{photo_back,jdbcType=VARCHAR}, REFEREE_NAME = #{referee_name,jdbcType=VARCHAR}, REFEREE_ID = #{referee_id,jdbcType=VARCHAR}, ADDRESS = #{address,jdbcType=VARCHAR}, CORP_ID = #{corp_id,jdbcType=VARCHAR}, CORP_NAME = #{corp_name,jdbcType=VARCHAR}, STATUS = #{status,jdbcType=INTEGER},update_time = #{update_time,jdbcType=VARCHAR}, REASON = #{reason,jdbcType=VARCHAR},apply_time = #{apply_time,jdbcType=VARCHAR}, APPLY_UID = #{apply_uid,jdbcType=INTEGER}, EXT1 = #{ext1,jdbcType=VARCHAR}, EXT2 = #{ext2,jdbcType=VARCHAR}, EXT3 = #{ext3,jdbcType=VARCHAR}, EXT4 = #{ext4,jdbcType=VARCHAR}, EXT5 = #{ext5,jdbcType=VARCHAR}, user_mobile = #{user_mobile,jdbcType=VARCHAR}, allot_time = #{allot_time,jdbcType=VARCHAR}, rule_deadline = #{rule_deadline,jdbcType=VARCHAR} WHERE ID = #{id}")
	public int updateT_member_partner(ApiT_member_partner t_member_partner);

	// 删除
	@Delete("DELETE FROM T_MEMBER_PARTNER  WHERE ID = #{ID}")
	public int deleteT_member_partner(Integer id);

	// Foreign keys revelant

	// region Indexs revelant

}
